CREATE TABLE [dbo].[GroupMemberOptions]
(
[GroupMemberKey] [uniqueidentifier] NOT NULL,
[OptOutFlag] [bit] NOT NULL,
[GroupContactFullAddressKey] [uniqueidentifier] NULL,
[GroupBillingFullAddressKey] [uniqueidentifier] NULL,
[AlternativeBillToContactKey] [uniqueidentifier] NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[GroupMemberOptions] ADD CONSTRAINT [PK_GroupMemberOptions] PRIMARY KEY CLUSTERED ([GroupMemberKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GroupMemberOptions_AlternativeBillToContactKey] ON [dbo].[GroupMemberOptions] ([AlternativeBillToContactKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GroupMemberOptions] ADD CONSTRAINT [FK_GroupMemberOptions_ContactMain] FOREIGN KEY ([AlternativeBillToContactKey]) REFERENCES [dbo].[ContactMain] ([ContactKey])
GO
ALTER TABLE [dbo].[GroupMemberOptions] ADD CONSTRAINT [FK_GroupMemberOptions_FullAddress_Billing] FOREIGN KEY ([GroupBillingFullAddressKey]) REFERENCES [dbo].[FullAddress] ([FullAddressKey])
GO
ALTER TABLE [dbo].[GroupMemberOptions] ADD CONSTRAINT [FK_GroupMemberOptions_FullAddress_Contact] FOREIGN KEY ([GroupContactFullAddressKey]) REFERENCES [dbo].[FullAddress] ([FullAddressKey])
GO
ALTER TABLE [dbo].[GroupMemberOptions] ADD CONSTRAINT [FK_GroupMemberOptions_GroupMember] FOREIGN KEY ([GroupMemberKey]) REFERENCES [dbo].[GroupMember] ([GroupMemberKey])
GO